using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class PT_ServiceBillDetailManagerBase
    {
        public PT_ServiceBillDetailManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity Insert(PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity Update(PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.Update(obj);             
        }
 
        public PT_ServiceBillDetailEntity Delete(PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.Delete(obj);             
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien AgentPrice 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByAgentPrice (double AgentPrice )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.AgentPrice = AgentPrice;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"AgentPrice");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByAmount (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Amount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Amount 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByAmount (double Amount )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Amount = Amount;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Amount");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByBill_NO (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Bill_NO 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByBill_NO (string Bill_NO )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Bill_NO = Bill_NO;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByComment (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Comment");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Comment 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByComment (string Comment )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Comment = Comment;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Comment");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByCreatedBy (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByCreatedBy (string CreatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedBy = CreatedBy;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByCreatedDate (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByCreatedDate (DateTime CreatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedDate = CreatedDate;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteById (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Id 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteById (Guid Id )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Id = Id;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Id");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByIntCode (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"IntCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IntCode 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByIntCode (int IntCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IntCode = IntCode;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"IntCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByIsDeleted (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByIsDeleted (bool IsDeleted )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IsDeleted = IsDeleted;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByOutPaid (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"OutPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutPaid 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByOutPaid (double OutPaid )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.OutPaid = OutPaid;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"OutPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByPrice (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Price");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Price 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByPrice (double Price )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Price = Price;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"Price");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteBySaleOffMoney (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"SaleOffMoney");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SaleOffMoney 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteBySaleOffMoney (double SaleOffMoney )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffMoney = SaleOffMoney;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"SaleOffMoney");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteBySaleOffReason (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"SaleOffReason");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SaleOffReason 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteBySaleOffReason (string SaleOffReason )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffReason = SaleOffReason;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"SaleOffReason");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByServiceCode (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"ServiceCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceCode 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByServiceCode (string ServiceCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceCode = ServiceCode;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"ServiceCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByServiceId (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"ServiceId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceId 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByServiceId (int ServiceId )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceId = ServiceId;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"ServiceId");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByUpdatedBy (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByUpdatedBy (string UpdatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedBy = UpdatedBy;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByUpdatedDate (PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate 
        /// </summary>
        /// <returns>PT_ServiceBillDetailEntity</returns>
        public PT_ServiceBillDetailEntity DeleteByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedDate = UpdatedDate;  
            return (PT_ServiceBillDetailEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public PT_ServiceBillDetailEntity Select(PT_ServiceBillDetailEntity obj)
        { 
            return (PT_ServiceBillDetailEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ServiceBillDetailEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ServiceBillDetailEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new PT_ServiceBillDetailEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new PT_ServiceBillDetailEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ServiceBillDetailEntity> SelectAllLST()
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ServiceBillDetailEntity()),new PT_ServiceBillDetailEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ServiceBillDetailEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ServiceBillDetailEntity(),option),new PT_ServiceBillDetailEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAgentPrice (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"AgentPrice");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAgentPrice (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"AgentPrice",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByAgentPriceLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AgentPrice"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByAgentPriceLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"AgentPrice",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAgentPrice (double AgentPrice )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.AgentPrice = AgentPrice;  
            return Adapter.SelectByField(obj,"AgentPrice");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAgentPrice (double AgentPrice, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.AgentPrice = AgentPrice;  
            return Adapter.SelectByField(obj,"AgentPrice",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByAgentPriceLST (double AgentPrice )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.AgentPrice = AgentPrice;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AgentPrice"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AgentPrice duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByAgentPriceLST (double AgentPrice, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.AgentPrice = AgentPrice;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AgentPrice",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"Amount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Amount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByAmountLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByAmountLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Amount",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (double Amount )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Amount = Amount;  
            return Adapter.SelectByField(obj,"Amount");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAmount (double Amount, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Amount = Amount;  
            return Adapter.SelectByField(obj,"Amount",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByAmountLST (double Amount )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Amount = Amount;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Amount duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByAmountLST (double Amount, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Amount = Amount;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Amount",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Bill_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByBill_NOLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByBill_NOLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Bill_NO",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (string Bill_NO )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Bill_NO = Bill_NO;  
            return Adapter.SelectByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (string Bill_NO, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Bill_NO = Bill_NO;  
            return Adapter.SelectByField(obj,"Bill_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByBill_NOLST (string Bill_NO )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Bill_NO = Bill_NO;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByBill_NOLST (string Bill_NO, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Bill_NO = Bill_NO;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"Comment");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Comment",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCommentLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCommentLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Comment",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (string Comment )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Comment = Comment;  
            return Adapter.SelectByField(obj,"Comment");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (string Comment, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Comment = Comment;  
            return Adapter.SelectByField(obj,"Comment",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCommentLST (string Comment )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Comment = Comment;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCommentLST (string Comment, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Comment = Comment;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedByLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedByLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedBy",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedByLST (string CreatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedByLST (string CreatedBy, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedDateLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedDateLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedDate",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedDateLST (DateTime CreatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByCreatedDateLST (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIdLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIdLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Id",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectById (Guid Id, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Id = Id;  
            return Adapter.SelectByField(obj,"Id",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIdLST (Guid Id )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Id = Id;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Id duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIdLST (Guid Id, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Id = Id;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Id",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIntCode (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"IntCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIntCode (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IntCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIntCodeLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IntCode"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIntCodeLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IntCode",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIntCode (int IntCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IntCode = IntCode;  
            return Adapter.SelectByField(obj,"IntCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIntCode (int IntCode, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IntCode = IntCode;  
            return Adapter.SelectByField(obj,"IntCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIntCodeLST (int IntCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IntCode = IntCode;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IntCode"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IntCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIntCodeLST (int IntCode, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IntCode = IntCode;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IntCode",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIsDeletedLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByIsDeletedLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsDeleted",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIsDeletedLST (bool IsDeleted )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByIsDeletedLST (bool IsDeleted, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"OutPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"OutPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByOutPaidLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByOutPaidLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"OutPaid",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (double OutPaid )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.OutPaid = OutPaid;  
            return Adapter.SelectByField(obj,"OutPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (double OutPaid, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.OutPaid = OutPaid;  
            return Adapter.SelectByField(obj,"OutPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByOutPaidLST (double OutPaid )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.OutPaid = OutPaid;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByOutPaidLST (double OutPaid, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.OutPaid = OutPaid;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"Price");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Price",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByPriceLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByPriceLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Price",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice (double Price )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Price = Price;  
            return Adapter.SelectByField(obj,"Price");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPrice (double Price, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Price = Price;  
            return Adapter.SelectByField(obj,"Price",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByPriceLST (double Price )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Price = Price;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Price duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByPriceLST (double Price, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.Price = Price;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Price",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffMoney (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"SaleOffMoney");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffMoney (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"SaleOffMoney",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffMoneyLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffMoney"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffMoneyLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"SaleOffMoney",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffMoney (double SaleOffMoney )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffMoney = SaleOffMoney;  
            return Adapter.SelectByField(obj,"SaleOffMoney");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffMoney (double SaleOffMoney, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffMoney = SaleOffMoney;  
            return Adapter.SelectByField(obj,"SaleOffMoney",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffMoneyLST (double SaleOffMoney )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffMoney = SaleOffMoney;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffMoney"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffMoneyLST (double SaleOffMoney, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffMoney = SaleOffMoney;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffMoney",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffReason (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"SaleOffReason");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffReason (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"SaleOffReason",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffReasonLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffReason"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffReasonLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"SaleOffReason",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffReason (string SaleOffReason )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffReason = SaleOffReason;  
            return Adapter.SelectByField(obj,"SaleOffReason");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySaleOffReason (string SaleOffReason, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffReason = SaleOffReason;  
            return Adapter.SelectByField(obj,"SaleOffReason",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffReasonLST (string SaleOffReason )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffReason = SaleOffReason;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffReason"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SaleOffReason duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectBySaleOffReasonLST (string SaleOffReason, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.SaleOffReason = SaleOffReason;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SaleOffReason",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceCode (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"ServiceCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceCode (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ServiceCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceCodeLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceCode"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceCodeLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ServiceCode",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceCode (string ServiceCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceCode = ServiceCode;  
            return Adapter.SelectByField(obj,"ServiceCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceCode (string ServiceCode, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceCode = ServiceCode;  
            return Adapter.SelectByField(obj,"ServiceCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceCodeLST (string ServiceCode )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceCode = ServiceCode;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceCode"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceCodeLST (string ServiceCode, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceCode = ServiceCode;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceCode",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceId (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"ServiceId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceId (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ServiceId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceIdLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceId"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceIdLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ServiceId",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceId (int ServiceId )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceId = ServiceId;  
            return Adapter.SelectByField(obj,"ServiceId");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceId (int ServiceId, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceId = ServiceId;  
            return Adapter.SelectByField(obj,"ServiceId",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceIdLST (int ServiceId )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceId = ServiceId;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceId"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceId duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByServiceIdLST (int ServiceId, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.ServiceId = ServiceId;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceId",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedByLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedByLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedByLST (string UpdatedBy )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedByLST (string UpdatedBy, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ServiceBillDetailEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedDateLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedDateLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedDateLST (DateTime UpdatedDate )
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillDetailEntity> SelectByUpdatedDateLST (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ServiceBillDetailEntity obj = new PT_ServiceBillDetailEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectWithConditionLST (PT_ServiceBillDetailEntity obj)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new PT_ServiceBillDetailEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillDetailEntity></returns>
        public List<PT_ServiceBillDetailEntity> SelectWithConditionLST (PT_ServiceBillDetailEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillDetailEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new PT_ServiceBillDetailEntity());
        }

}
}
